Accidentes Sonora - tidy Profiling Report

Dataset statistics

Number of variables	19
Number of observations	1800
Missing cells	0
Missing cells (%)	0.0%
Duplicate rows	0
Duplicate rows (%)	0.0%
Total size in memory	267.3 KiB
Average record size in memory	152.1 B

Variable types

Numeric	18
Categorical	1

Alerts

`Nombre_Municipio` has a high cardinality: 72 distinct values	High cardinality
`Unnamed: 0` is highly overall correlated with `Año` and 1 other fields	High correlation
`Año` is highly overall correlated with `Unnamed: 0` and 1 other fields	High correlation
`Id_Municipio` is highly overall correlated with `Nombre_Municipio`	High correlation
`Poblacion` is highly overall correlated with `Nombre_Municipio` and 7 other fields	High correlation
`Total_Accidentes` is highly overall correlated with `Nombre_Municipio` and 7 other fields	High correlation
`Tasa_Accidentes` is highly overall correlated with `Nombre_Municipio` and 4 other fields	High correlation
`Total_Muertes` is highly overall correlated with `Nombre_Municipio` and 6 other fields	High correlation
`Tasa_Muertos` is highly overall correlated with `Tasa_Accidentes` and 4 other fields	High correlation
`Total_Muertes_Alcohol` is highly overall correlated with `Nombre_Municipio` and 5 other fields	High correlation
`Tasa_Muertos_Alcohol` is highly overall correlated with `Tasa_Muertos` and 2 other fields	High correlation
`Total_Heridos` is highly overall correlated with `Nombre_Municipio` and 6 other fields	High correlation
`Tasa_Heridos` is highly overall correlated with `Tasa_Accidentes` and 4 other fields	High correlation
`Total_Heridos_Alcohol` is highly overall correlated with `Nombre_Municipio` and 5 other fields	High correlation
`Tasa_Heridos_Alcohol` is highly overall correlated with `Tasa_Muertos` and 3 other fields	High correlation
`Total_Cinturon_Uso` is highly overall correlated with `Poblacion` and 4 other fields	High correlation
`Total_Cinturon_Tasa` is highly overall correlated with `Nombre_Municipio` and 6 other fields	High correlation
`Total_Fugas` is highly overall correlated with `Nombre_Municipio` and 5 other fields	High correlation
`Total_Fugas_Tasa` is highly overall correlated with `Unnamed: 0` and 3 other fields	High correlation
`Nombre_Municipio` is highly overall correlated with `Id_Municipio` and 10 other fields	High correlation
`Unnamed: 0` is uniformly distributed	Uniform
`Nombre_Municipio` is uniformly distributed	Uniform
`Unnamed: 0` has unique values	Unique
`Total_Accidentes` has 254 (14.1%) zeros	Zeros
`Tasa_Accidentes` has 254 (14.1%) zeros	Zeros
`Total_Muertes` has 894 (49.7%) zeros	Zeros
`Tasa_Muertos` has 894 (49.7%) zeros	Zeros
`Total_Muertes_Alcohol` has 1366 (75.9%) zeros	Zeros
`Tasa_Muertos_Alcohol` has 1366 (75.9%) zeros	Zeros
`Total_Heridos` has 528 (29.3%) zeros	Zeros
`Tasa_Heridos` has 528 (29.3%) zeros	Zeros
`Total_Heridos_Alcohol` has 871 (48.4%) zeros	Zeros
`Tasa_Heridos_Alcohol` has 871 (48.4%) zeros	Zeros
`Total_Cinturon_Uso` has 997 (55.4%) zeros	Zeros
`Total_Cinturon_Tasa` has 997 (55.4%) zeros	Zeros
`Total_Fugas` has 1009 (56.1%) zeros	Zeros
`Total_Fugas_Tasa` has 1009 (56.1%) zeros	Zeros

Reproduction

Analysis started	2022-12-12 22:39:37.046580
Analysis finished	2022-12-12 22:41:10.787580
Duration	1 minute and 33.74 seconds
Software version	pandas-profiling vv3.5.0
Download configuration	config.json

Unnamed: 0
Real number (ℝ)

HIGH CORRELATION
UNIFORM
UNIQUE

Distinct	1800
Distinct (%)	100.0%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	899.5

Minimum	0
Maximum	1799
Zeros	1
Zeros (%)	0.1%
Negative	0
Negative (%)	0.0%
Memory size	14.2 KiB

Quantile statistics

Minimum	0
5-th percentile	89.95
Q1	449.75
median	899.5
Q3	1349.25
95-th percentile	1709.05
Maximum	1799
Range	1799
Interquartile range (IQR)	899.5

Descriptive statistics

Standard deviation	519.75956
Coefficient of variation (CV)	0.57783164
Kurtosis	-1.2
Mean	899.5
Median Absolute Deviation (MAD)	450
Skewness	0
Sum	1619100
Variance	270150
Monotonicity	Strictly increasing

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
0	1	0.1%
1237	1	0.1%
1207	1	0.1%
1206	1	0.1%
1205	1	0.1%
1204	1	0.1%
1203	1	0.1%
1202	1	0.1%
1201	1	0.1%
1200	1	0.1%
Other values (1790)	1790	99.4%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
0	1	0.1%
1	1	0.1%
2	1	0.1%
3	1	0.1%
4	1	0.1%
5	1	0.1%
6	1	0.1%
7	1	0.1%
8	1	0.1%
9	1	0.1%

Value	Count	Frequency (%)
1799	1	0.1%
1798	1	0.1%
1797	1	0.1%
1796	1	0.1%
1795	1	0.1%
1794	1	0.1%
1793	1	0.1%
1792	1	0.1%
1791	1	0.1%
1790	1	0.1%

Año
Real number (ℝ)

Distinct	25
Distinct (%)	1.4%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	2009

Minimum	1997
Maximum	2021
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	14.2 KiB

Quantile statistics

Minimum	1997
5-th percentile	1998
Q1	2003
median	2009
Q3	2015
95-th percentile	2020
Maximum	2021
Range	24
Interquartile range (IQR)	12

Descriptive statistics

Standard deviation	7.2131065
Coefficient of variation (CV)	0.0035903965
Kurtosis	-1.2038561
Mean	2009
Median Absolute Deviation (MAD)	6
Skewness	0
Sum	3616200
Variance	52.028905
Monotonicity	Increasing

Histogram with fixed size bins (bins=25)

Value	Count	Frequency (%)
1997	72	4.0%
2010	72	4.0%
2020	72	4.0%
2019	72	4.0%
2018	72	4.0%
2017	72	4.0%
2016	72	4.0%
2015	72	4.0%
2014	72	4.0%
2013	72	4.0%
Other values (15)	1080	60.0%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
1997	72	4.0%
1998	72	4.0%
1999	72	4.0%
2000	72	4.0%
2001	72	4.0%
2002	72	4.0%
2003	72	4.0%
2004	72	4.0%
2005	72	4.0%
2006	72	4.0%

Value	Count	Frequency (%)
2021	72	4.0%
2020	72	4.0%
2019	72	4.0%
2018	72	4.0%
2017	72	4.0%
2016	72	4.0%
2015	72	4.0%
2014	72	4.0%
2013	72	4.0%
2012	72	4.0%

Id_Municipio
Real number (ℝ)

Distinct	72
Distinct (%)	4.0%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	36.5

Minimum	1
Maximum	72
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	14.2 KiB

Quantile statistics

Minimum	1
5-th percentile	4
Q1	18.75
median	36.5
Q3	54.25
95-th percentile	69
Maximum	72
Range	71
Interquartile range (IQR)	35.5

Descriptive statistics

Standard deviation	20.78838
Coefficient of variation (CV)	0.56954466
Kurtosis	-1.2004636
Mean	36.5
Median Absolute Deviation (MAD)	18
Skewness	0
Sum	65700
Variance	432.15675
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
1	25	1.4%
2	25	1.4%
53	25	1.4%
52	25	1.4%
51	25	1.4%
50	25	1.4%
49	25	1.4%
48	25	1.4%
47	25	1.4%
46	25	1.4%
Other values (62)	1550	86.1%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
1	25	1.4%
2	25	1.4%
3	25	1.4%
4	25	1.4%
5	25	1.4%
6	25	1.4%
7	25	1.4%
8	25	1.4%
9	25	1.4%
10	25	1.4%

Value	Count	Frequency (%)
72	25	1.4%
71	25	1.4%
70	25	1.4%
69	25	1.4%
68	25	1.4%
67	25	1.4%
66	25	1.4%
65	25	1.4%
64	25	1.4%
63	25	1.4%

Nombre_Municipio
Categorical

HIGH CARDINALITY
HIGH CORRELATION
UNIFORM

Distinct	72
Distinct (%)	4.0%
Missing	0
Missing (%)	0.0%
Memory size	14.2 KiB

Aconchi	25
Agua Prieta	25
San Felipe de Jesús	25
Sahuaripa	25
Rosario	25
Other values (67)	1675

Length

Max length	29
Median length	21
Mean length	9.5
Min length	4

Characters and Unicode

Total characters	17100
Distinct characters	51
Distinct categories	3 ?
Distinct scripts	2 ?
Distinct blocks	2 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	Aconchi
2nd row	Agua Prieta
3rd row	Alamos
4th row	Altar
5th row	Arivechi

Common Values

Value	Count	Frequency (%)
Aconchi	25	1.4%
Agua Prieta	25	1.4%
San Felipe de Jesús	25	1.4%
Sahuaripa	25	1.4%
Rosario	25	1.4%
Rayón	25	1.4%
Quiriego	25	1.4%
Puerto Peñasco	25	1.4%
Pitiquito	25	1.4%
Oquitoa	25	1.4%
Other values (62)	1550	86.1%

Length

Histogram of lengths of the category

Value	Count	Frequency (%)
san	150	5.7%
de	100	3.8%
santa	50	1.9%
la	50	1.9%
río	50	1.9%
villa	50	1.9%
aconchi	25	1.0%
baviácora	25	1.0%
atil	25	1.0%
bacadéhuachi	25	1.0%
Other values (83)	2075	79.0%

Most occurring characters

Value	Count	Frequency (%)
a	2575	15.1%
e	1175	6.9%
o	1175	6.9%
i	1075	6.3%
r	1025	6.0%
	825	4.8%
c	800	4.7%
u	750	4.4%
n	700	4.1%
s	650	3.8%
Other values (41)	6350	37.1%

Most occurring categories

Value	Count	Frequency (%)
Lowercase Letter	13775	80.6%
Uppercase Letter	2500	14.6%
Space Separator	825	4.8%

Most frequent character per category

Lowercase Letter

Value	Count	Frequency (%)
a	2575	18.7%
e	1175	8.5%
o	1175	8.5%
i	1075	7.8%
r	1025	7.4%
c	800	5.8%
u	750	5.4%
n	700	5.1%
s	650	4.7%
l	625	4.5%
Other values (18)	3225	23.4%

Uppercase Letter

Value	Count	Frequency (%)
S	300	12.0%
C	300	12.0%
B	250	10.0%
H	200	8.0%
A	200	8.0%
P	175	7.0%
M	125	5.0%
N	125	5.0%
G	125	5.0%
R	100	4.0%
Other values (12)	600	24.0%

Space Separator

Value	Count	Frequency (%)
	825	100.0%

Most occurring scripts

Value	Count	Frequency (%)
Latin	16275	95.2%
Common	825	4.8%

Most frequent character per script

Latin

Value	Count	Frequency (%)
a	2575	15.8%
e	1175	7.2%
o	1175	7.2%
i	1075	6.6%
r	1025	6.3%
c	800	4.9%
u	750	4.6%
n	700	4.3%
s	650	4.0%
l	625	3.8%
Other values (40)	5725	35.2%

Common

Value	Count	Frequency (%)
	825	100.0%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	16600	97.1%
None	500	2.9%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
a	2575	15.5%
e	1175	7.1%
o	1175	7.1%
i	1075	6.5%
r	1025	6.2%
	825	5.0%
c	800	4.8%
u	750	4.5%
n	700	4.2%
s	650	3.9%
Other values (35)	5850	35.2%

None

Value	Count	Frequency (%)
á	200	40.0%
í	125	25.0%
é	75	15.0%
ó	50	10.0%
ñ	25	5.0%
ú	25	5.0%

Poblacion
Real number (ℝ)

Distinct	211
Distinct (%)	11.7%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	34075.043

Minimum	279
Maximum	936263
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	14.2 KiB

Quantile statistics

Minimum	279
5-th percentile	492
Q1	1454
median	3396
Q3	14365
95-th percentile	157729
Maximum	936263
Range	935984
Interquartile range (IQR)	12911

Descriptive statistics

Standard deviation	99457.403
Coefficient of variation (CV)	2.9187756
Kurtosis	33.195767
Mean	34075.043
Median Absolute Deviation (MAD)	2571
Skewness	5.3591128
Sum	61335077
Variance	9.891775 × 10⁹
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
1484	26	1.4%
1350	20	1.1%
1646	20	1.1%
1496	15	0.8%
943	15	0.8%
3335	13	0.7%
5626	13	0.7%
279	13	0.7%
416	13	0.7%
6400	13	0.7%
Other values (201)	1639	91.1%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
279	13	0.7%
365	2	0.1%
369	2	0.1%
396	10	0.6%
399	10	0.6%
402	13	0.7%
416	13	0.7%
443	10	0.6%
479	13	0.7%
492	10	0.6%

Value	Count	Frequency (%)
936263	2	0.1%
784342	10	0.6%
609829	13	0.7%
436484	2	0.1%
409310	10	0.6%
356290	13	0.7%
264782	2	0.1%
220292	10	0.6%
199021	2	0.1%
178380	10	0.6%

Total_Accidentes
Real number (ℝ)

HIGH CORRELATION
ZEROS

Distinct	398
Distinct (%)	22.1%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	215.46667

Minimum	0
Maximum	8693
Zeros	254
Zeros (%)	14.1%
Negative	0
Negative (%)	0.0%
Memory size	14.2 KiB

Quantile statistics

Minimum	0
5-th percentile	0
Q1	3
median	12
Q3	61.25
95-th percentile	1343.05
Maximum	8693
Range	8693
Interquartile range (IQR)	58.25

Descriptive statistics

Standard deviation	671.34511
Coefficient of variation (CV)	3.1157725
Kurtosis	32.203927
Mean	215.46667
Median Absolute Deviation (MAD)	12
Skewness	5.0385323
Sum	387840
Variance	450704.26
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
0	254	14.1%
12	161	8.9%
1	97	5.4%
2	68	3.8%
3	59	3.3%
5	58	3.2%
4	52	2.9%
6	44	2.4%
8	40	2.2%
7	31	1.7%
Other values (388)	936	52.0%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
0	254	14.1%
1	97	5.4%
2	68	3.8%
3	59	3.3%
4	52	2.9%
5	58	3.2%
6	44	2.4%
7	31	1.7%
8	40	2.2%
9	29	1.6%

Value	Count	Frequency (%)
8693	1	0.1%
5157	1	0.1%
5005	1	0.1%
4790	1	0.1%
4612	1	0.1%
4462	1	0.1%
4435	1	0.1%
4430	1	0.1%
4393	1	0.1%
4390	1	0.1%

Tasa_Accidentes
Real number (ℝ)

HIGH CORRELATION
ZEROS

Distinct	1250
Distinct (%)	69.4%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	5.0334616

Minimum	0
Maximum	37.313433
Zeros	254
Zeros (%)	14.1%
Negative	0
Negative (%)	0.0%
Memory size	14.2 KiB

Quantile statistics

Minimum	0
5-th percentile	0
Q1	1.2891918
median	3.7252757
Q3	7.2248812
95-th percentile	14.966261
Maximum	37.313433
Range	37.313433
Interquartile range (IQR)	5.9356893

Descriptive statistics

Standard deviation	5.1760902
Coefficient of variation (CV)	1.0283361
Kurtosis	5.5859836
Mean	5.0334616
Median Absolute Deviation (MAD)	2.7511022
Skewness	1.9582689
Sum	9060.2308
Variance	26.79191
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
0	254	14.1%
5.028284098	5	0.3%
2.087682672	5	0.3%
5.336179296	5	0.3%
4.043126685	4	0.2%
0.4336513443	4	0.2%
12.47401247	4	0.2%
1.751313485	4	0.2%
8.021390374	4	0.2%
1.212856277	4	0.2%
Other values (1240)	1507	83.7%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
0	254	14.1%
0.04689991558	1	0.1%
0.1001201442	1	0.1%
0.1193032689	1	0.1%
0.1647717911	1	0.1%
0.1895734597	1	0.1%
0.2006420546	1	0.1%
0.2979737783	2	0.1%
0.299850075	1	0.1%
0.3206898395	1	0.1%

Value	Count	Frequency (%)
37.31343284	1	0.1%
32.87671233	2	0.1%
32.59259259	1	0.1%
32.5203252	2	0.1%
30.3030303	2	0.1%
30.07518797	3	0.2%
29.34537246	1	0.1%
27.08803612	2	0.1%
25.06265664	1	0.1%
24.87562189	1	0.1%

Total_Muertes
Real number (ℝ)

HIGH CORRELATION
ZEROS

Distinct	57
Distinct (%)	3.2%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	3.6605556

Minimum	0
Maximum	180
Zeros	894
Zeros (%)	49.7%
Negative	0
Negative (%)	0.0%
Memory size	14.2 KiB

Quantile statistics

Minimum	0
5-th percentile	0
Q1	0
median	1
Q3	3
95-th percentile	19
Maximum	180
Range	180
Interquartile range (IQR)	3

Descriptive statistics

Standard deviation	9.2275176
Coefficient of variation (CV)	2.520797
Kurtosis	88.569314
Mean	3.6605556
Median Absolute Deviation (MAD)	1
Skewness	6.9528838
Sum	6589
Variance	85.147081
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
0	894	49.7%
1	252	14.0%
2	166	9.2%
3	84	4.7%
4	62	3.4%
5	49	2.7%
6	34	1.9%
7	25	1.4%
8	22	1.2%
9	20	1.1%
Other values (47)	192	10.7%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
0	894	49.7%
1	252	14.0%
2	166	9.2%
3	84	4.7%
4	62	3.4%
5	49	2.7%
6	34	1.9%
7	25	1.4%
8	22	1.2%
9	20	1.1%

Value	Count	Frequency (%)
180	1	0.1%
80	1	0.1%
75	2	0.1%
67	1	0.1%
65	1	0.1%
62	1	0.1%
61	1	0.1%
55	1	0.1%
54	2	0.1%
53	1	0.1%

Tasa_Muertos
Real number (ℝ)

HIGH CORRELATION
ZEROS

Distinct	574
Distinct (%)	31.9%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	0.22562231

Minimum	0
Maximum	10.204082
Zeros	894
Zeros (%)	49.7%
Negative	0
Negative (%)	0.0%
Memory size	14.2 KiB

Quantile statistics

Minimum	0
5-th percentile	0
Q1	0
median	0.016979858
Q3	0.21123785
95-th percentile	1.0600732
Maximum	10.204082
Range	10.204082
Interquartile range (IQR)	0.21123785

Descriptive statistics

Standard deviation	0.57664477
Coefficient of variation (CV)	2.5557967
Kurtosis	102.84306
Mean	0.22562231
Median Absolute Deviation (MAD)	0.016979858
Skewness	8.0670968
Sum	406.12016
Variance	0.33251919
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
0	894	49.7%
0.1840942563	9	0.5%
0.6075334143	7	0.4%
0.2757479664	6	0.3%
0.07393168712	5	0.3%
0.1392272885	5	0.3%
1.481481481	5	0.3%
0.6142506143	5	0.3%
0.2137932263	5	0.3%
0.1862197393	5	0.3%
Other values (564)	854	47.4%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
0	894	49.7%
0.004582069446	1	0.1%
0.006873104169	1	0.1%
0.01251666281	1	0.1%
0.01263615457	1	0.1%
0.01339593701	1	0.1%
0.01614361359	1	0.1%
0.01781610219	1	0.1%
0.02000520135	2	0.1%
0.02009390552	1	0.1%

Value	Count	Frequency (%)
10.20408163	1	0.1%
9.029345372	1	0.1%
7.462686567	1	0.1%
5.050505051	1	0.1%
4.975124378	1	0.1%
4.175365344	1	0.1%
4.032258065	1	0.1%
3.584229391	1	0.1%
2.90486565	2	0.1%
2.791346825	1	0.1%

Total_Muertes_Alcohol
Real number (ℝ)

HIGH CORRELATION
ZEROS

Distinct	13
Distinct (%)	0.7%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	0.52333333

Minimum	0
Maximum	18
Zeros	1366
Zeros (%)	75.9%
Negative	0
Negative (%)	0.0%
Memory size	14.2 KiB

Quantile statistics

Minimum	0
5-th percentile	0
Q1	0
median	0
Q3	0
95-th percentile	3
Maximum	18
Range	18
Interquartile range (IQR)	0

Descriptive statistics

Standard deviation	1.3380771
Coefficient of variation (CV)	2.5568352
Kurtosis	34.886616
Mean	0.52333333
Median Absolute Deviation (MAD)	0
Skewness	4.7874853
Sum	942
Variance	1.7904503
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=13)

Value	Count	Frequency (%)
0	1366	75.9%
1	218	12.1%
2	112	6.2%
3	36	2.0%
4	31	1.7%
5	11	0.6%
6	10	0.6%
7	4	0.2%
9	3	0.2%
10	3	0.2%
Other values (3)	6	0.3%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
0	1366	75.9%
1	218	12.1%
2	112	6.2%
3	36	2.0%
4	31	1.7%
5	11	0.6%
6	10	0.6%
7	4	0.2%
8	3	0.2%
9	3	0.2%

Value	Count	Frequency (%)
18	1	0.1%
13	2	0.1%
10	3	0.2%
9	3	0.2%
8	3	0.2%
7	4	0.2%
6	10	0.6%
5	11	0.6%
4	31	1.7%
3	36	2.0%

Tasa_Muertos_Alcohol
Real number (ℝ)

HIGH CORRELATION
ZEROS

Distinct	257
Distinct (%)	14.3%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	0.064876429

Minimum	0
Maximum	6.772009
Zeros	1366
Zeros (%)	75.9%
Negative	0
Negative (%)	0.0%
Memory size	14.2 KiB

Quantile statistics

Minimum	0
5-th percentile	0
Q1	0
median	0
Q3	0
95-th percentile	0.33086866
Maximum	6.772009
Range	6.772009
Interquartile range (IQR)	0

Descriptive statistics

Standard deviation	0.29878806
Coefficient of variation (CV)	4.6054949
Kurtosis	195.04314
Mean	0.064876429
Median Absolute Deviation (MAD)	0
Skewness	11.389324
Sum	116.77757
Variance	0.089274305
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
0	1366	75.9%
0.01310684702	10	0.6%
0.6075334143	8	0.4%
0.06419103251	6	0.3%
0.03119054303	5	0.3%
0.01438517751	5	0.3%
0.01263615457	5	0.3%
0.15625	5	0.3%
0.1105094486	4	0.2%
0.01251666281	4	0.2%
Other values (247)	382	21.2%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
0	1366	75.9%
0.001274954038	1	0.1%
0.002136151915	1	0.1%
0.002443136009	1	0.1%
0.002549908076	1	0.1%
0.002806702405	3	0.2%
0.00327960789	2	0.1%
0.003824862114	1	0.1%
0.004539429485	3	0.2%
0.004886272019	1	0.1%

Value	Count	Frequency (%)
6.772009029	1	0.1%
4.975124378	1	0.1%
2.487562189	1	0.1%
2.424242424	1	0.1%
2.257336343	2	0.1%
2.087682672	1	0.1%
2.079002079	1	0.1%
2.070393375	1	0.1%
1.766784452	1	0.1%
1.597444089	1	0.1%

Total_Heridos
Real number (ℝ)

HIGH CORRELATION
ZEROS

Distinct	315
Distinct (%)	17.5%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	96.795

Minimum	0
Maximum	3894
Zeros	528
Zeros (%)	29.3%
Negative	0
Negative (%)	0.0%
Memory size	14.2 KiB

Quantile statistics

Minimum	0
5-th percentile	0
Q1	0
median	5
Q3	27.25
95-th percentile	568.1
Maximum	3894
Range	3894
Interquartile range (IQR)	27.25

Descriptive statistics

Standard deviation	328.25288
Coefficient of variation (CV)	3.3912173
Kurtosis	45.943497
Mean	96.795
Median Absolute Deviation (MAD)	5
Skewness	6.0975732
Sum	174231
Variance	107749.95
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
0	528	29.3%
1	120	6.7%
2	110	6.1%
4	69	3.8%
3	67	3.7%
5	56	3.1%
6	48	2.7%
9	32	1.8%
7	32	1.8%
8	29	1.6%
Other values (305)	709	39.4%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
0	528	29.3%
1	120	6.7%
2	110	6.1%
3	67	3.7%
4	69	3.8%
5	56	3.1%
6	48	2.7%
7	32	1.8%
8	29	1.6%
9	32	1.8%

Value	Count	Frequency (%)
3894	1	0.1%
3711	1	0.1%
3125	1	0.1%
3103	1	0.1%
3021	1	0.1%
2895	1	0.1%
2735	1	0.1%
2548	1	0.1%
2503	1	0.1%
2318	1	0.1%

Tasa_Heridos
Real number (ℝ)

HIGH CORRELATION
ZEROS

Distinct	1053
Distinct (%)	58.5%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	2.147162

Minimum	0
Maximum	64.676617
Zeros	528
Zeros (%)	29.3%
Negative	0
Negative (%)	0.0%
Memory size	14.2 KiB

Quantile statistics

Minimum	0
5-th percentile	0
Q1	0
median	1.2150668
Q3	2.8260116
95-th percentile	6.9637883
Maximum	64.676617
Range	64.676617
Interquartile range (IQR)	2.8260116

Descriptive statistics

Standard deviation	3.6526968
Coefficient of variation (CV)	1.7011743
Kurtosis	72.087031
Mean	2.147162
Median Absolute Deviation (MAD)	1.2150668
Skewness	6.4095979
Sum	3864.8917
Variance	13.342194
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
0	528	29.3%
1.215066829	6	0.3%
0.7320644217	5	0.3%
0.537056928	5	0.3%
0.8718395815	5	0.3%
1.271364161	4	0.2%
2.673796791	4	0.2%
2.69541779	4	0.2%
0.3791469194	4	0.2%
0.8756567426	4	0.2%
Other values (1043)	1231	68.4%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
0	528	29.3%
0.02574599006	1	0.1%
0.07338372349	1	0.1%
0.07737542556	1	0.1%
0.09379983116	1	0.1%
0.1082719792	2	0.1%
0.1281886938	1	0.1%
0.1378739832	2	0.1%
0.1562255898	1	0.1%
0.1612383102	1	0.1%

Value	Count	Frequency (%)
64.67661692	1	0.1%
40	1	0.1%
39.80099502	1	0.1%
39.25925926	1	0.1%
25.25252525	1	0.1%
24.83069977	2	0.1%
23.4791889	1	0.1%
22.55639098	1	0.1%
21.63461538	1	0.1%
20.83333333	1	0.1%

Total_Heridos_Alcohol
Real number (ℝ)

HIGH CORRELATION
ZEROS

Distinct	147
Distinct (%)	8.2%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	16.117222

Minimum	0
Maximum	959
Zeros	871
Zeros (%)	48.4%
Negative	0
Negative (%)	0.0%
Memory size	14.2 KiB

Quantile statistics

Minimum	0
5-th percentile	0
Q1	0
median	1
Q3	6
95-th percentile	78.05
Maximum	959
Range	959
Interquartile range (IQR)	6

Descriptive statistics

Standard deviation	61.128639
Coefficient of variation (CV)	3.7927528
Kurtosis	92.145956
Mean	16.117222
Median Absolute Deviation (MAD)	1
Skewness	8.4341049
Sum	29011
Variance	3736.7105
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
0	871	48.4%
1	143	7.9%
2	113	6.3%
3	90	5.0%
4	54	3.0%
5	49	2.7%
6	42	2.3%
7	33	1.8%
8	30	1.7%
9	23	1.3%
Other values (137)	352	19.6%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
0	871	48.4%
1	143	7.9%
2	113	6.3%
3	90	5.0%
4	54	3.0%
5	49	2.7%
6	42	2.3%
7	33	1.8%
8	30	1.7%
9	23	1.3%

Value	Count	Frequency (%)
959	1	0.1%
864	1	0.1%
763	1	0.1%
627	1	0.1%
610	1	0.1%
604	1	0.1%
561	1	0.1%
537	1	0.1%
508	1	0.1%
499	1	0.1%

Tasa_Heridos_Alcohol
Real number (ℝ)

HIGH CORRELATION
ZEROS

Distinct	750
Distinct (%)	41.7%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	0.62103672

Minimum	0
Maximum	19.259259
Zeros	871
Zeros (%)	48.4%
Negative	0
Negative (%)	0.0%
Memory size	14.2 KiB

Quantile statistics

Minimum	0
5-th percentile	0
Q1	0
median	0.045415126
Q3	0.65063918
95-th percentile	2.6954178
Maximum	19.259259
Range	19.259259
Interquartile range (IQR)	0.65063918

Descriptive statistics

Standard deviation	1.5654563
Coefficient of variation (CV)	2.5207146
Kurtosis	50.697881
Mean	0.62103672
Median Absolute Deviation (MAD)	0.045415126
Skewness	6.144043
Sum	1117.8661
Variance	2.4506534
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
0	871	48.4%
0.6075334143	7	0.4%
0.7320644217	4	0.2%
0.8861320337	4	0.2%
0.8944543828	4	0.2%
0.7407407407	4	0.2%
0.268528464	4	0.2%
0.2388344877	3	0.2%
0.5617977528	3	0.2%
0.2002402883	3	0.2%
Other values (740)	893	49.6%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
0	871	48.4%
0.007329408028	1	0.1%
0.01267997642	3	0.2%
0.01339593701	1	0.1%
0.0174392243	1	0.1%
0.01824961828	1	0.1%
0.01954508808	1	0.1%
0.02512297697	2	0.1%
0.02803004821	1	0.1%
0.03036191402	1	0.1%

Value	Count	Frequency (%)
19.25925926	1	0.1%
18.05869074	1	0.1%
17.41293532	1	0.1%
16.82692308	1	0.1%
15.15151515	1	0.1%
14.49275362	1	0.1%
12.62626263	1	0.1%
12.43781095	1	0.1%
11.47959184	1	0.1%
11.28668172	1	0.1%

Total_Cinturon_Uso
Real number (ℝ)

HIGH CORRELATION
ZEROS

Distinct	129
Distinct (%)	7.2%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	38.865556

Minimum	0
Maximum	7367
Zeros	997
Zeros (%)	55.4%
Negative	0
Negative (%)	0.0%
Memory size	14.2 KiB

Quantile statistics

Minimum	0
5-th percentile	0
Q1	0
median	0
Q3	2
95-th percentile	54.05
Maximum	7367
Range	7367
Interquartile range (IQR)	2

Descriptive statistics

Standard deviation	283.78326
Coefficient of variation (CV)	7.3016648
Kurtosis	288.63108
Mean	38.865556
Median Absolute Deviation (MAD)	0
Skewness	14.465297
Sum	69958
Variance	80532.939
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
0	997	55.4%
1	226	12.6%
2	140	7.8%
3	84	4.7%
4	41	2.3%
5	33	1.8%
6	27	1.5%
8	16	0.9%
13	12	0.7%
7	12	0.7%
Other values (119)	212	11.8%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
0	997	55.4%
1	226	12.6%
2	140	7.8%
3	84	4.7%
4	41	2.3%
5	33	1.8%
6	27	1.5%
7	12	0.7%
8	16	0.9%
9	11	0.6%

Value	Count	Frequency (%)
7367	1	0.1%
3316	1	0.1%
2975	1	0.1%
2845	1	0.1%
2724	1	0.1%
2456	1	0.1%
2440	1	0.1%
2339	1	0.1%
2247	1	0.1%
2217	1	0.1%

Total_Cinturon_Tasa
Real number (ℝ)

HIGH CORRELATION
ZEROS

Distinct	588
Distinct (%)	32.7%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	0.58112096

Minimum	0
Maximum	16.677879
Zeros	997
Zeros (%)	55.4%
Negative	0
Negative (%)	0.0%
Memory size	14.2 KiB

Quantile statistics

Minimum	0
5-th percentile	0
Q1	0
median	0
Q3	0.48736339
95-th percentile	3.1111067
Maximum	16.677879
Range	16.677879
Interquartile range (IQR)	0.48736339

Descriptive statistics

Standard deviation	1.4925317
Coefficient of variation (CV)	2.5683667
Kurtosis	38.445754
Mean	0.58112096
Median Absolute Deviation (MAD)	0
Skewness	5.2775828
Sum	1046.0177
Variance	2.227651
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
0	997	55.4%
0.8718395815	6	0.3%
0.08119519324	4	0.2%
2.525252525	4	0.2%
0.1571832757	4	0.2%
0.4875670405	4	0.2%
0.2177463255	4	0.2%
0.1612383102	4	0.2%
1.215066829	4	0.2%
0.2808988764	4	0.2%
Other values (578)	765	42.5%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
0	997	55.4%
0.002443136009	1	0.1%
0.002806702405	1	0.1%
0.003776691769	1	0.1%
0.004539429485	1	0.1%
0.005613404811	1	0.1%
0.006339988208	1	0.1%
0.007329408028	1	0.1%
0.00767288938	1	0.1%
0.009078858969	3	0.2%

Value	Count	Frequency (%)
16.67787869	1	0.1%
15.94909743	1	0.1%
15.27077027	1	0.1%
14.92537313	1	0.1%
14.07407407	1	0.1%
12.59259259	1	0.1%
12.34040629	1	0.1%
11.73959445	1	0.1%
11.13952799	1	0.1%
10.02506266	1	0.1%

Total_Fugas
Real number (ℝ)

HIGH CORRELATION
ZEROS

Distinct	177
Distinct (%)	9.8%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	24.787778

Minimum	0
Maximum	2176
Zeros	1009
Zeros (%)	56.1%
Negative	0
Negative (%)	0.0%
Memory size	14.2 KiB

Quantile statistics

Minimum	0
5-th percentile	0
Q1	0
median	0
Q3	9.25
95-th percentile	154.4
Maximum	2176
Range	2176
Interquartile range (IQR)	9.25

Descriptive statistics

Standard deviation	100.49868
Coefficient of variation (CV)	4.0543643
Kurtosis	166.1693
Mean	24.787778
Median Absolute Deviation (MAD)	0
Skewness	10.530983
Sum	44618
Variance	10099.985
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
0	1009	56.1%
12	107	5.9%
1	96	5.3%
2	54	3.0%
3	44	2.4%
11	36	2.0%
6	32	1.8%
10	29	1.6%
4	28	1.6%
8	27	1.5%
Other values (167)	338	18.8%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
0	1009	56.1%
1	96	5.3%
2	54	3.0%
3	44	2.4%
4	28	1.6%
5	26	1.4%
6	32	1.8%
7	19	1.1%
8	27	1.5%
9	15	0.8%

Value	Count	Frequency (%)
2176	1	0.1%
1558	1	0.1%
949	1	0.1%
939	1	0.1%
881	1	0.1%
857	1	0.1%
786	1	0.1%
752	1	0.1%
742	1	0.1%
723	1	0.1%

Total_Fugas_Tasa
Real number (ℝ)

HIGH CORRELATION
ZEROS

Distinct	663
Distinct (%)	36.8%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	1.1263939

Minimum	0
Maximum	32.876712
Zeros	1009
Zeros (%)	56.1%
Negative	0
Negative (%)	0.0%
Memory size	14.2 KiB

Quantile statistics

Minimum	0
5-th percentile	0
Q1	0
median	0
Q3	0.55009004
95-th percentile	7.0087993
Maximum	32.876712
Range	32.876712
Interquartile range (IQR)	0.55009004

Descriptive statistics

Standard deviation	3.4315181
Coefficient of variation (CV)	3.0464636
Kurtosis	35.341204
Mean	1.1263939
Median Absolute Deviation (MAD)	0
Skewness	5.3531269
Sum	2027.509
Variance	11.775316
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
0	1009	56.1%
0.06244536031	4	0.2%
0.7407407407	3	0.2%
0.1160631383	3	0.2%
0.4983388704	3	0.2%
0.4543595802	3	0.2%
0.5005005005	3	0.2%
0.1612383102	3	0.2%
0.1913509376	3	0.2%
0.1157541382	3	0.2%
Other values (653)	763	42.4%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
0	1009	56.1%
0.004582069446	1	0.1%
0.005613404811	1	0.1%
0.006873104169	1	0.1%
0.006896266361	1	0.1%
0.008199019725	1	0.1%
0.01310684702	1	0.1%
0.01646985194	1	0.1%
0.01781610219	1	0.1%
0.02433282437	2	0.1%

Value	Count	Frequency (%)
32.87671233	2	0.1%
32.5203252	2	0.1%
30.3030303	1	0.1%
30.07518797	2	0.1%
27.08803612	2	0.1%
24.3902439	2	0.1%
22.34636872	2	0.1%
22.17741935	2	0.1%
19.2	2	0.1%
19.16932907	1	0.1%

Auto

The auto setting is an interpretable pairwise column metric of the following mapping:

Variable_type-Variable_type : Method, Range
Categorical-Categorical : Cramer's V, [0,1]
Numerical-Categorical : Cramer's V, [0,1] (using a discretized numerical column)
Numerical-Numerical : Spearman's ρ, [-1,1]

The number of bins used in the discretization for the Numerical-Categorical column pair can be changed using config.correlations["auto"].n_bins. The number of bins affects the granularity of the association you wish to measure.

This configuration uses the recommended metric for each pair of columns.

Spearman's ρ

The Spearman's rank correlation coefficient (ρ) is a measure of monotonic correlation between two variables, and is therefore better in catching nonlinear monotonic correlations than Pearson's r. It's value lies between -1 and +1, -1 indicating total negative monotonic correlation, 0 indicating no monotonic correlation and 1 indicating total positive monotonic correlation.

To calculate ρ for two variables X and Y, one divides the covariance of the rank variables of X and Y by the product of their standard deviations.

Pearson's r

The Pearson's correlation coefficient (r) is a measure of linear correlation between two variables. It's value lies between -1 and +1, -1 indicating total negative linear correlation, 0 indicating no linear correlation and 1 indicating total positive linear correlation. Furthermore, r is invariant under separate changes in location and scale of the two variables, implying that for a linear function the angle to the x-axis does not affect r.

To calculate r for two variables X and Y, one divides the covariance of X and Y by the product of their standard deviations.

Kendall's τ

Similarly to Spearman's rank correlation coefficient, the Kendall rank correlation coefficient (τ) measures ordinal association between two variables. It's value lies between -1 and +1, -1 indicating total negative correlation, 0 indicating no correlation and 1 indicating total positive correlation.

To calculate τ for two variables X and Y, one determines the number of concordant and discordant pairs of observations. τ is given by the number of concordant pairs minus the discordant pairs divided by the total number of pairs.

Phik (φk)

Phik (φk) is a new and practical correlation coefficient that works consistently between categorical, ordinal and interval variables, captures non-linear dependency and reverts to the Pearson correlation coefficient in case of a bivariate normal input distribution. There is extensive documentation available here.

Count
Matrix

A simple visualization of nullity by column.

Nullity matrix is a data-dense display which lets you quickly visually pick out patterns in data completion.

First rows
Last rows

	Unnamed: 0	Año	Id_Municipio	Nombre_Municipio	Poblacion	Total_Accidentes	Tasa_Accidentes	Total_Muertes	Tasa_Muertos	Total_Muertes_Alcohol	Tasa_Muertos_Alcohol	Total_Heridos	Tasa_Heridos	Total_Heridos_Alcohol	Tasa_Heridos_Alcohol	Total_Fugas	Total_Fugas_Tasa
0	0	1997	1	Aconchi	2420	0	0.000000	0	0.000000	0	0.000000	0	0.000000	0	0.000000	0	0.000000
1	1	1997	2	Agua Prieta	61944	0	0.000000	0	0.000000	0	0.000000	0	0.000000	0	0.000000	0	0.000000
2	2	1997	3	Alamos	25152	43	1.709606	4	0.159033	1	0.039758	21	0.834924	6	0.238550	5	0.198791
3	3	1997	4	Altar	7253	9	1.240866	0	0.000000	0	0.000000	1	0.137874	0	0.000000	2	0.275748
4	4	1997	5	Arivechi	1484	2	1.347709	1	0.673854	0	0.000000	0	0.000000	0	0.000000	0	0.000000
5	5	1997	6	Arizpe	3396	8	2.355713	2	0.588928	0	0.000000	5	1.472320	1	0.294464	0	0.000000
6	6	1997	7	Atil	718	0	0.000000	0	0.000000	0	0.000000	0	0.000000	0	0.000000	0	0.000000
7	7	1997	8	Bacadéhuachi	1348	0	0.000000	0	0.000000	0	0.000000	0	0.000000	0	0.000000	0	0.000000
8	8	1997	9	Bacanora	943	0	0.000000	0	0.000000	0	0.000000	0	0.000000	0	0.000000	0	0.000000
9	9	1997	10	Bacerac	1366	0	0.000000	0	0.000000	0	0.000000	0	0.000000	0	0.000000	0	0.000000

	Unnamed: 0	Año	Id_Municipio	Nombre_Municipio	Poblacion	Total_Accidentes	Tasa_Accidentes	Total_Muertes	Tasa_Muertos	Total_Muertes_Alcohol	Tasa_Muertos_Alcohol	Total_Heridos	Tasa_Heridos	Total_Heridos_Alcohol	Tasa_Heridos_Alcohol	Total_Cinturon_Uso	Total_Cinturon_Tasa	Total_Fugas	Total_Fugas_Tasa
1790	1790	2021	63	Tepache	1178	12	10.186757	0	0.000000	0	0.000000	0	0.000000	0	0.000000	0	0.000000	12	10.186757
1791	1791	2021	64	Trincheras	1381	12	8.689356	0	0.000000	0	0.000000	0	0.000000	0	0.000000	0	0.000000	12	8.689356
1792	1792	2021	65	Tubutama	1473	12	8.146640	0	0.000000	0	0.000000	0	0.000000	0	0.000000	0	0.000000	12	8.146640
1793	1793	2021	66	Ures	8548	25	2.924661	0	0.000000	0	0.000000	3	0.350959	2	0.233973	2	0.233973	4	0.467946
1794	1794	2021	67	Villa Hidalgo	1429	12	8.397481	1	0.699790	0	0.000000	0	0.000000	0	0.000000	0	0.000000	11	7.697691
1795	1795	2021	68	Villa Pesqueira	1043	13	12.464046	0	0.000000	0	0.000000	0	0.000000	0	0.000000	1	0.958773	12	11.505273
1796	1796	2021	69	Yécora	4793	13	2.712289	0	0.000000	0	0.000000	0	0.000000	0	0.000000	3	0.625913	10	2.086376
1797	1797	2021	70	General Plutarco Elías Calles	13627	60	4.403023	1	0.073384	0	0.000000	1	0.073384	0	0.000000	3	0.220151	11	0.807221
1798	1798	2021	71	Benito Juárez	21692	98	4.517795	0	0.000000	0	0.000000	43	1.982298	0	0.000000	0	0.000000	5	0.230500
1799	1799	2021	72	San Ignacio Río Muerto	14279	53	3.711745	4	0.280132	4	0.280132	42	2.941382	3	0.210099	0	0.000000	0	0.000000

Overview

Variables

Common Values

Length

Most occurring characters

Most occurring categories

Most frequent character per category

Lowercase Letter

Uppercase Letter

Space Separator

Most occurring scripts

Most frequent character per script

Latin

Common

Most occurring blocks

Most frequent character per block

ASCII

None

Interactions

Correlations

Auto

Spearman's ρ

Pearson's r

Kendall's τ

Phik (φk)

Missing values

Sample